/*
 Navicat Premium Data Transfer

 Source Server         : vagrant
 Source Server Type    : MySQL
 Source Server Version : 50743 (5.7.43-log)
 Source Host           : 192.168.18.88:3306
 Source Schema         : myl_abc

 Target Server Type    : MySQL
 Target Server Version : 50743 (5.7.43-log)
 File Encoding         : 65001

 Date: 15/01/2024 18:17:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for myl_config
-- ----------------------------
DROP TABLE IF EXISTS `myl_config`;
CREATE TABLE `myl_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8mb4_unicode_ci,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `field_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `is_hide` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_unique` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统配置表';

-- ----------------------------
-- Records of myl_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_doc
-- ----------------------------
DROP TABLE IF EXISTS `myl_doc`;
CREATE TABLE `myl_doc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
  `mid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '模型ID',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级ID',
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
  `subtitle` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '短标题',
  `keywords` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '关键词',
  `description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述',
  `pubdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `flag` set('j','p','b','s','a','f','c','h') COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '自定义属性',
  `tpl` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '内容模板',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人',
  `author` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '作者',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `site_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `cid_title` (`cid`,`title`) USING BTREE,
  KEY `cid` (`cid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='文档基础表';

-- ----------------------------
-- Records of myl_doc
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_doc_article
-- ----------------------------
DROP TABLE IF EXISTS `myl_doc_article`;
CREATE TABLE `myl_doc_article` (
  `aid` int(10) unsigned NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`aid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='文档内容表';

-- ----------------------------
-- Records of myl_doc_article
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_site
-- ----------------------------
DROP TABLE IF EXISTS `myl_site`;
CREATE TABLE `myl_site` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点标题',
  `keywords` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点关键词',
  `description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点描述',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='站点表';

-- ----------------------------
-- Records of myl_site
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `myl_sys_dept`;
CREATE TABLE `myl_sys_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `pid` bigint(20) DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '部门名称',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `leader` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `status` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部门表';

-- ----------------------------
-- Records of myl_sys_dept
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `myl_sys_dict`;
CREATE TABLE `myl_sys_dict` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '字典名称',
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '字典类型',
  `status` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '是否已删除（0正常 1已删除）',
  `remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='字典类型表';

-- ----------------------------
-- Records of myl_sys_dict
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `myl_sys_dict_data`;
CREATE TABLE `myl_sys_dict_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `label` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) COLLATE utf8mb4_unicode_ci DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `status` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `is_Deleted` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '是否已删除（0正常 1已删除）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='字典数据表';

-- ----------------------------
-- Records of myl_sys_dict_data
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_sys_logininfo
-- ----------------------------
DROP TABLE IF EXISTS `myl_sys_logininfo`;
CREATE TABLE `myl_sys_logininfo` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `username` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户账号',
  `login_ip` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '操作系统',
  `status` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`id`),
  KEY `idx_sys_logininfor_s` (`status`),
  KEY `idx_sys_logininfor_lt` (`login_time`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统访问记录';

-- ----------------------------
-- Records of myl_sys_logininfo
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `myl_sys_menu`;
CREATE TABLE `myl_sys_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单',
  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单标识',
  `icon` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图标',
  `perms` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '节点地址',
  `weight` tinyint(4) unsigned NOT NULL DEFAULT '100' COMMENT '权重（排序）',
  `menu_type` enum('M','C','A') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限类型: M=目录，C=菜单，A=按钮',
  `is_show` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示1是0否',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态1正常0禁用',
  `is_deleted` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态1删除0未删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='后台权限菜单节点';

-- ----------------------------
-- Records of myl_sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `myl_sys_menu` (`id`, `parent_id`, `name`, `icon`, `perms`, `weight`, `menu_type`, `is_show`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (153, 0, '仪表', '', 'dashboard', 100, 'M', 1, '2024-01-15 15:00:21', '2024-01-15 15:00:21', 1, 0);
INSERT INTO `myl_sys_menu` (`id`, `parent_id`, `name`, `icon`, `perms`, `weight`, `menu_type`, `is_show`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (154, 153, '工作台', '', 'dashboard:workplace', 100, 'M', 1, '2024-01-15 15:27:37', '2024-01-15 15:27:37', 1, 0);
INSERT INTO `myl_sys_menu` (`id`, `parent_id`, `name`, `icon`, `perms`, `weight`, `menu_type`, `is_show`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (155, 153, '实时监控', '', 'dashboard:monitor', 100, 'M', 1, '2024-01-15 15:28:16', '2024-01-15 15:28:16', 1, 0);
INSERT INTO `myl_sys_menu` (`id`, `parent_id`, `name`, `icon`, `perms`, `weight`, `menu_type`, `is_show`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (156, 0, '系统', '', 'system', 100, 'M', 1, '2024-01-15 18:16:11', '2024-01-15 18:16:11', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for myl_sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `myl_sys_oper_log`;
CREATE TABLE `myl_sys_oper_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '返回参数',
  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `cost_time` bigint(20) DEFAULT '0' COMMENT '消耗时间',
  `create_time` datetime DEFAULT NULL COMMENT '操作时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` char(1) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '是否已删除（0否 1是）',
  PRIMARY KEY (`id`),
  KEY `idx_sys_oper_log_bt` (`business_type`),
  KEY `idx_sys_oper_log_s` (`status`),
  KEY `idx_sys_oper_log_ot` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='操作日志记录';

-- ----------------------------
-- Records of myl_sys_oper_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for myl_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `myl_sys_role`;
CREATE TABLE `myl_sys_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `alias` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标识',
  `description` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述',
  `rules` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '权限集合',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1正常2禁用',
  `is_deleted` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '删除0未删除1已删除',
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`) USING BTREE,
  KEY `is_deleted` (`is_deleted`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='后台角色表';

-- ----------------------------
-- Records of myl_sys_role
-- ----------------------------
BEGIN;
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (3, '超级管理员', 'admin', '真的超级管理员', '', '2024-01-09 13:40:24', '2024-01-09 13:40:24', 1, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (4, '编辑', 'editor', '编辑人员集合区', '', '2024-01-09 16:49:53', '2024-01-09 13:41:59', 1, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (5, '销售', 'saler', '真的销售员', '', '2024-01-09 16:37:27', '2024-01-09 16:37:27', 1, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (6, 'dddddd', 'sdsds', '232322', '', '2024-01-15 11:04:09', '2024-01-11 18:28:56', 0, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (9, '测试项目', 'sffddv', '', '', '2024-01-15 09:24:35', '2024-01-12 13:24:26', 0, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (10, 'notnumber', 'must_yw', '123eee###', '', '2024-01-15 09:22:59', '2024-01-12 13:25:34', 1, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (11, 'werw', 'werwerw', 'werwerw', '', '2024-01-15 11:04:18', '2024-01-12 13:34:37', 0, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (12, 'hehe', 'asdfdsa', '3424323542', '', '2024-01-15 11:04:22', '2024-01-12 13:48:14', 0, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (13, '中文名', 'demo', '这个是介绍', '', '2024-01-12 13:55:35', '2024-01-12 13:55:35', 1, 0);
INSERT INTO `myl_sys_role` (`id`, `name`, `alias`, `description`, `rules`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (14, '仪表', 'dashboard', '100', '', '2024-01-15 14:01:29', '2024-01-15 14:01:29', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for myl_user
-- ----------------------------
DROP TABLE IF EXISTS `myl_user`;
CREATE TABLE `myl_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '登录账号',
  `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码\n',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `avatar` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '头像',
  `mobile` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '手机号',
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '邮箱地址',
  `mobile_ckd` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '手机已验证0否1是',
  `email_ckd` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '邮箱已验证0否1是',
  `last_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_ip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '上次登录ip',
  `is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否可以登录后台',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1正常2禁用',
  `is_deleted` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否已删除0否1是',
  PRIMARY KEY (`id`),
  UNIQUE KEY `myl_user_username_IDX` (`username`) USING BTREE,
  KEY `myl_user_is_deleted_IDX` (`is_deleted`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';

-- ----------------------------
-- Records of myl_user
-- ----------------------------
BEGIN;
INSERT INTO `myl_user` (`id`, `username`, `password`, `nickname`, `avatar`, `mobile`, `email`, `mobile_ckd`, `email_ckd`, `last_time`, `last_ip`, `is_admin`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (2, 'admin', '123456', '超级管理员', 0, '15210093981', 'ixiaomu@qq.com', 0, 0, '2024-01-15 16:55:00', '192.168.12.2', 0, '2023-12-22 14:42:16', '2023-12-22 14:42:16', 1, 0);
INSERT INTO `myl_user` (`id`, `username`, `password`, `nickname`, `avatar`, `mobile`, `email`, `mobile_ckd`, `email_ckd`, `last_time`, `last_ip`, `is_admin`, `update_time`, `create_time`, `status`, `is_deleted`) VALUES (3, 'zhangsan', '123456', '张三', 0, '15210093982', 'ixiaom2u@qq.com', 0, 0, '2023-12-29 16:04:03', '', 0, '2023-12-22 14:45:16', '2023-12-22 14:45:16', 1, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
